Hi i am trying to load Oracle data as source to Sql DB. i get an error as : [OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E14 Description: "ORA-00936: missing expression". [DTS.Pipeline] Error: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_ISBROKEN". Can anyone help me to solve this issue. thanks.

Ignore the VS_ISBROKEN bit, that's not important. Of more interest is: "ORA-00936: missing expression" That's an error returned from Oracle. If I were you I would get rid of SSIS from the equation. Take your query and run it directly against Oracle using your favourite query tool and diagnose in there what the problem is. @Jamiet http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Does the query use parameters which are populated from one or many SSIS variable ?? If yes , then that could be where the sql is losing its syntax. Regards, Sandeep

Agree with Jamie on this one... This is an issue with your Oracle query.Please 'Mark as Answer' if found helpful - Chris@tier-1-support [